Paul Turley's SQL Server BI Blog
sharing my experiences with the Microsoft data platform, SQL Server BI, Data Modeling, SSAS Design, Power Pivot, Power BI, SSRS Advanced Design, Power BI, Dashboards & Visualization since 2009
Please help me develop some useful information for analysis – about the Microsoft BI & reporting products you are using. There will be more polls in the future. I’ll share the results for all. Questions, suggestions or feedback? Leave a comment and I’ll reply.
Please take a poll and see the results:
Are you using or planning to move to a SharePoint BI solution?
Your participation is appreciated. In the future, use the POLLS menu bar button to find the latest poll questions and results.
The Lakehouse is the evolution of the earlier cloud data platform in many pieces that came with “some assembly required”. All of the components are modern, mature and capable but complicated and require specialized skills. Imagine that the new version is easier to assemble with instructions that are only a few pages with stick figures, and it comes with an Allen wrench.
We’re seeing consulting customers putting Lakehouse and BI solutions on-line in just a few weeks. Then they iterate to scale-up their modern data warehouse/BI platform as they train their Center of Excellence champions and Data Governance organizations as they progress.
In a recent blog post, Paul discussed that DevOps, and specifically CI/CD, principles are essential for modern software development, and Power BI is no exception. Power BI CI/CD for enterprise class projects can be achieved using Azure DevOps, with steps including source control, automated testing, and build and release pipelines.
Even for small, informal BI projects, shaping the data into a dimensional model alleviates complexity, speeds up slow calculations and reduces the data model storage size. I conclude this post by reviewing seven data architectures and the data shaping methods with different degrees of scale.
really good post – helped me a lot! What about a post about SQL Jobs? I have recently managed to get one and found this site to be extremely useful. Worth a try: SQL Jobs
Vishal, You can see the results yourself. Go to the poll page and click on the View results link in the lower-left. It took me a couple tries to figure it out the first time.
Pleases share result when u r done !!