Fabric Analyst in a Day

In this introductory module, Zane explains the essentials of the Fabric Analyst in a Day course, emphasizing the need for specific tools like Power BI Desktop and access to Fabric capacity or premium capacity. The course is designed for data analysts working with Fabric, covering various workloads and practical applications, including shortcuts, pipelines, and data flow Gen 2. Zane also highlights the availability of a Fabric free trial and the steps to provision a Fabric capacity if the trial is not an option.

In this module of Fabric Analyst in a Day, Zane Goodman provides an overview of Microsoft Fabric, emphasizing its role in simplifying complex data environments by unifying various data and analytics tools into a single platform. He explains how Fabric integrates Microsoft Power BI, Azure Synapse Analytics, and Azure Data Factory, offering a cohesive experience for data professionals. Zane also highlights the four key promises of Fabric, including a complete analytics platform, lake-centric and open service, empowerment of business users, and built-in AI capabilities.

In this module, Zane introduces OneLake, a software-as-a-service data lake that unifies an organization's data across multiple clouds, eliminating data duplication and integration challenges. He explains that OneLake is automatically provisioned, built on the Delta Parquet format, and allows seamless data sharing and virtualization within the organization. Zane uses a mansion analogy to illustrate how different workspaces and data items are organized within OneLake, emphasizing its managed, scalable, and open-access nature.

In this module, Zane introduces the scenario for Fabrikam Inc., a wholesale novelty goods distributor, and outlines the data sources and challenges faced by the company's data analysts. The focus is on understanding the integration of various data sources into a Power BI report to help Fabrikam expand its sales globally. Zane also walks through a Power BI report, highlighting key insights and visualizations that will guide the learning process throughout the course.

In this module, Zane guides students through the process of creating a workspace and a lake house within Microsoft Fabric, emphasizing the various workloads available, such as data engineering, data science, and data warehousing. Zane explains the concept of a lake house, highlighting its role in storing, managing, and analyzing data, and demonstrates how to navigate and utilize different tools within the platform. By the end of the module, students will have hands-on experience in setting up a workspace and a lake house, preparing them for further exploration and application of Microsoft Fabric's capabilities.

In this module, Zane guides students through the process of creating shortcuts in Microsoft Fabric, emphasizing their ability to connect to various data stores without data movement. He demonstrates how to use these shortcuts to virtualize data from external sources like ADLS Gen 2 and Amazon S3, and then leverage this data in visual queries and SQL endpoints. By the end of the module, students will have created multiple views using the Power Query editor, enhancing their data management and transformation skills within the Fabric environment.

In this module, Zane guides students through the process of creating Dataflow Gen 2 in Microsoft Fabric, emphasizing its advantages over Dataflow Gen 1, such as the ability to specify data destinations. The session includes practical steps for connecting to data sources like Azure SQL Database and Snowflake, and demonstrates how to load data into a lake house. By the end of the module, students will have hands-on experience in setting up data flows and understanding their application in data integration and transformation tasks.

In this module, Zane explains how to use data pipelines in Microsoft Fabric to refresh data efficiently. He covers the creation and configuration of pipelines, emphasizing the use of variables and activities to handle data refreshes at specific times and manage potential delays. By the end of the module, students will understand how to set up and schedule data pipelines to ensure timely and accurate data updates

In this module, Zane guides students through the process of building a semantic model and SQL view using Power BI, emphasizing the importance of semantic models in analyzing large data volumes efficiently. He explains how to create relationships and measures within the model, ensuring a single version of truth across the organization. The session concludes with practical steps to visualize data and create reports, leveraging the capabilities of Power BI for real-time data analysis.

In this module, Zane guides students through the process of building a Power BI report using measures and relationships created in previous modules. He demonstrates how to leverage features like auto-creating reports from semantic models and customizing visuals to enhance data presentation. Additionally, Zane explains the benefits of Direct Lake mode for real-time data updates without the need for frequent refreshes, showcasing its efficiency in handling large datasets.

In this module, Zane introduces the forecasting model demo within Microsoft Fabric, highlighting its practical applications for data engineers and data scientists. He explains how to create and utilize notebooks for developing Apache Spark jobs and machine learning experiments, emphasizing the integration of Python, Spark SQL, and T-SQL. The demo showcases the process of installing the Prophet library, running code to generate forecasts, and analyzing the results through various visualizations.

In this module, Zane demonstrates the use of Data Activator to monitor sales variance percentages by stock group name, specifically setting up alerts for variances below 20%. Despite Data Activator being in preview and having some bugs, Zane effectively guides through creating a measure, setting up a table visual, and configuring alerts to notify when sales variances fall below the threshold. This practical demo helps students understand how to leverage Data Activator for real-time data monitoring and alerting in a business context.

In the final module of the Fabric Analyst in a Day course, Zane introduces the concept of data warehousing, emphasizing its relevance for data engineers and its distinction from the lake house. He explains that a data warehouse serves as a SQL endpoint, allowing for operations like UPDATE, DELETE, DROP, and ALTER, and supports cross-database querying and Fabric Mirroring to connect with external databases. Zane concludes by highlighting the integrated Power BI semantic layer and the flexibility in data set modes, wrapping up the course with a comprehensive overview of Fabric's end-to-end analytics capabilities.