BI Tracks

#BusinessIntelligence consulting and solutions organization specializing in the tools from Microsoft's BI stack including #SQL, #SSRS, #SSIS, #SSAS and #BIML

[BI Tracks @BITracks]

Meet #bimlSnap, the best way to accelerate your ELT/ETL process. See what the pros have to say who use it:
https://t.co/B3hTSmHkbB

[BI Tracks @BITracks]

Save the date! We'll be at @CincyPASS for SQL Saturday Cincinnati in just a month! Find the BI Tracks booth and sit in on our session covering Azure Data Studio. March 21st.
#sqlsaturday #sqlfamily

https://t.co/J33LdJVoFY

[BI Tracks @BITracks]

https://t.co/BNNjLXGojE

[BI Tracks @BITracks]

Get to know the BI Tracks team! First is our founder and fearless leader, Jim Miller, @BIforBreakfast

Jim spends his days helping companies build their data warehouse with accuracy and efficiency. Whether it is in the cloud or on-prem, Jim is the ELT guru. #MeetTheTeam

[Changelog @changelog]

how to navigate a legacy codebase

[BI Tracks @BITracks]

Cool off in the waters of a well orchestrated data lake. Read more about how we helped one of our clients take dispersed, unorganized data into something they could actually use.
#casestudy #datalake
vhttps://www.bitracks.com/case-study

[BI Tracks @BITracks]

Did you know we also do consulting?
BI Tracks offers Power BI consulting to help you make sense of your data. If you need some help, contact one of our consultants today.

https://t.co/Hke5wZo318

[BI Tracks @BITracks]

@SttPgh thanks Stephen! Let us know if you have any questions or issues.

[BI Tracks @BITracks]

Rather than spending our whole lives writing merge statements for tables with 100s of attributes, we now create merge statements programmatically with eltSnap and bimlSnap's code generators.

[BI Tracks @BITracks]

#ThursdayThoughts Or questions...
How long does it take you to write a typical merge statement in your work? Taking into account testing to get ready for deployment.

[BI Tracks @BITracks]

Nice infographic on the differences of #ETL and #ELT methodologies, by @twaintaylor on @TechTarget

[BI Tracks @BITracks]

Six years on twitter, but many, many more years of doing Data Warehousing and loving to solve problems. #MyTwitterAnniversary

[BI Tracks @BITracks]

For Modern, Cloud based Data Warehousing, we use an Extract, Load, then Transform (ELT) paradigm vs. the more common ETL methodology. Do you see value in using an (ELT) approach; and does this one letter swap mean a large shift in the way you perform Data Integration?

[BI Tracks @BITracks]

#ThrowbackThursday To this post on the BI Tracks blog on ELT vs. ETL for SSIS. https://t.co/TgTV7YAyF9

[BI Tracks @BITracks]

ELT, say what? We prefer to Extract, Load and then Transform data. Here is a #ThrowbackThursday post to last year on why we prefer to do ELT vs. ETL data integration. https://t.co/TgTV7YAyF9 Which do you do/prefer, ELT or ETL?

[BI Tracks @BITracks]

...and with you.
Happy Star Wars Day!

[BI Tracks @BITracks]

A match made in heaven!

Through the magic of Python and eltSnap’s custom runtime, you can now effortlessly create your data warehouse in the cloud with @SnowflakeDB .
Learn more about eltSnap by going to https://t.co/PKl2b3tW3f.

[BI Tracks @BITracks]

Day in Day out learning. This is baked into our work approach and how we continually build our products. #addictedtoproblemsolving

[BI Tracks @BITracks]

@_akhilm Hopefully all is well Akhil!

[BI Tracks @BITracks]

New product alert! We are pleased to present eltSnap. Bypass SSIS entirely by creating packages 10x faster and use our custom runtime.

Request your free download here:
https://t.co/SqkNBxuXqC

[BI Tracks @BITracks]

Any followers of our blog, heads up! We've moved it to our new home at https://t.co/dU1ugxf4vb - @BIforBreakfast's current wordpress blog will remain up for a little while still to let everyone move with us.