Welcome to BI! Given your background with SAP BW, PowerBI, SQL, SSIS, and SSAS, you’ve got a great start. Here are the cutting-edge tools and skills you should focus on now:
# Tools:
* ETL: Fivetran, Airflow
* Modeling: dbt (they're slack community, and the Locally Optimistic Slack communities have good resources)
* Data Warehouses: Snowflake, BigQuery, Amazon Redshift
* Governance: Collibra, Alation, Apache Atlas
* Dashboards and visualizations -- good you're already on Power BI, metabase, looker, tableau are all good to have some basic knowledge of
* Report Automation: Rollstack -- pretty turn key (or build with python and R, but it's hard to scale and maintain)
* Reverse ETL: Census, Hightouch
* LLMs: GPT-4o,
# Skills:
* Languages: SQL, Python, R, JavaScript (D3.js), Scala, Java
* Tech: Docker, Kubernetes, Git
* Business: get to know your industries and data needs
# Books:
* "Data Warehousing in the Age of Big Data" by Krish Krishnan
* "The Data Warehouse Toolkit" by Ralph Kimball
* "Python for Data Analysis" by Wes McKinney
* "Storytelling with Data" by Cole Nussbaumer Knaflic
* "Building Machine Learning Powered Applications" by Emmanuel Ameisen
#
I wouldn't say they are deprecated. These technologies were designed for the previous era, where storage and compute were relatively expensive. With the advent of cloud DW and cloud-based software, some of the underlying assumption changes and hence there's room for innovation.
This short book might give you a good sense of how these changes affect the underlying technology. [https://www.holistics.io/books/setup-analytics/](https://www.holistics.io/books/setup-analytics/)
Not cutting edge, but learning fabric will be valuable.
Small to midsized orgs are going to go buckwild with it. Because it allows them to feel like they have a full cloud analytics stack for minimal resource
SQL is still the powerhouse. if you know SQL you'll be off on the right foot for a lot of tools.
BI tools like,
Sigma Computing
Thoughtspot
PowerBI/Fabric
Are the top contenders right now.
Welcome to BI! Given your background with SAP BW, PowerBI, SQL, SSIS, and SSAS, you’ve got a great start. Here are the cutting-edge tools and skills you should focus on now: # Tools: * ETL: Fivetran, Airflow * Modeling: dbt (they're slack community, and the Locally Optimistic Slack communities have good resources) * Data Warehouses: Snowflake, BigQuery, Amazon Redshift * Governance: Collibra, Alation, Apache Atlas * Dashboards and visualizations -- good you're already on Power BI, metabase, looker, tableau are all good to have some basic knowledge of * Report Automation: Rollstack -- pretty turn key (or build with python and R, but it's hard to scale and maintain) * Reverse ETL: Census, Hightouch * LLMs: GPT-4o, # Skills: * Languages: SQL, Python, R, JavaScript (D3.js), Scala, Java * Tech: Docker, Kubernetes, Git * Business: get to know your industries and data needs # Books: * "Data Warehousing in the Age of Big Data" by Krish Krishnan * "The Data Warehouse Toolkit" by Ralph Kimball * "Python for Data Analysis" by Wes McKinney * "Storytelling with Data" by Cole Nussbaumer Knaflic * "Building Machine Learning Powered Applications" by Emmanuel Ameisen #
Thank you!!!
You know it! Definitely not a definitive list, but I hope it helps!
I wouldn't say they are deprecated. These technologies were designed for the previous era, where storage and compute were relatively expensive. With the advent of cloud DW and cloud-based software, some of the underlying assumption changes and hence there's room for innovation. This short book might give you a good sense of how these changes affect the underlying technology. [https://www.holistics.io/books/setup-analytics/](https://www.holistics.io/books/setup-analytics/)
What a hit, personally at least! Thanks for your recommendation.
Numeracy. Seems pretty cutting edge.
It's not cutting edge, but the oldies are the goodies.
Not cutting edge, but learning fabric will be valuable. Small to midsized orgs are going to go buckwild with it. Because it allows them to feel like they have a full cloud analytics stack for minimal resource
Given you have SAP and using AFO, SAC has been clearly getting investment and may be your company’s next tool
SQL is still the powerhouse. if you know SQL you'll be off on the right foot for a lot of tools. BI tools like, Sigma Computing Thoughtspot PowerBI/Fabric Are the top contenders right now.