Connect to a data warehouse in Azure and create dynamic reports in Microsoft Power BI.
Kiefer Consulting will work collaboratively with your organization to connect to an Azure SQL Database and create reports in Microsoft Power BI.
Duration :10 days Transform up to 3 (tables, CSV or Excel files) into Azure SQL Database using Azure Data Factory Kiefer will build one proof of concept visualization using Power BI Demonstrate findings to customer Provide two-hour knowledge transfer session with customer
Data must be accessible to the Azure Data Factory Volume of data should be large enough and diverse enough to create meaningful visuals Data quality should be relatively good, resulting in limited transformation effort
Azure Data Factory
Azure Data Factory is the platform that solves such data scenarios. It is the cloud-based ETL and data integration service that allows you to create data-driven workflows for orchestrating data movement and transforming data at scale. Using Azure Data Factory, you can create and schedule data-driven workflows (called pipelines) that can ingest data from disparate data stores. You can build complex ETL processes that transform data visually with data flows or by using compute services such as Azure HDInsight Hadoop, Azure Databricks, and Azure SQL Database.
Connect to and visualize any data using the unified, scalable platform for self-service and enterprise business intelligence (BI) that’s easy to use and helps you gain deeper data insight.
Azure SQL Database
Azure SQL Database is a fully managed platform as a service (PaaS) database engine that handles most of the database management functions such as upgrading, patching, backups, and monitoring without user involvement. Azure SQL Database is always running on the latest stable version of the SQL Server database engine and patched OS with 99.99% availability. PaaS capabilities that are built into Azure SQL Database enable you to focus on the domain-specific database administration and optimization activities that are critical for