6:00PM – 6:30PM social | 6:30PM – 8:30PM meeting
Part 2 – A Best Practice Guide and Checklist for Power BI Projects
In December’s short session, Paul introduced a set of guidelines for Power BI projects. This deep-dive session will explore those best practices with several examples and hands-on demonstrations.
Whether designing moderate-scale reports for a few business users or large-scale solutions with loads of data for an entire corporation, this session provides best practice guidance for the essential components of Power BI projects. Power BI is a very flexible platform with an vast range of options and often overwhelming design choices. We will discuss recommended practices to manage datasets and reports for team collaboration, version control, query optimization for scale, data modeling design patterns, measure design, dataset certification and governance. We will conclude with a complete checklist of important items to ensure project success.
Paul is a Principal Consultant for Pragmatic Works, a Mentor and Microsoft Data Platform MVP. He consults, writes, speaks, teaches & blogs about business intelligence and reporting solutions. He works with companies around the world to model data, visualize and deliver critical information to make informed business decisions; using the Microsoft data platform and business analytics tools. He is a Director of the Oregon SQL PASS chapter & user group, the author and lead author of Professional SQL Server 2016 Reporting Services and 14 other titles from Wrox & Microsoft Press. He holds several certifications including MCSE for the Data Platform and BI.
Refreshments graciously provided by ServerLogic.
Glad I Pushed Back
An anecdotal presentation about Q & A including a use-case for the RAND operator in T-SQL. I am an intermediate Data Analyst with not quite a full year of professional experience. After being tasked with a project to compare tables between two servers to check for inconsistencies, I developed a method for screening large random samples. My suggestion was turned down for a method developed by someone with over 20 years of BI experience. I obviously went the advice of my co-worker and followed his format… once or twice. I later compared the results of his method to that of my Q&A which had a much more profound impact than my previous explanation.
Currently, I work as a Data Analyst at Columbia Distributing. The IT Data Analytics team is fantastic and I am hoping to build a long and happy career there. I am also a masters student at Washington State University where I am continuing my education in Business Administration with a focus on International Business. At WSU I earned my Bachelor of Arts degree in Business Administration and received the Dean’s award for academic achievement in 2019. I studied at Clark College in 2017-2018 where I earned an Associates degree in business administration, was an active member of Phi Theta Kappa, and made the VP Honor Roll List.
We wish to acknowledge the OSHU Information Technology Group for supporting Oregon SQL by generously providing the meeting venue.