| PowerBI Lead - Architect || Hoffman Estates, IL at Hoffman, Minnesota, USA |
| Email: [email protected] |
|
From: Kaveri, Tek Pyramids [email protected] Reply to: [email protected] PowerBI Lead / Architect Hoffman Estates, IL 12+ Months Phone/Skype Hire Any Visa is OK ! Requirements : Expertise in Power BI Desktop, including creating and managing reports, creating reports, KPI metrics, charts, publishing, distributing information, and data models. Ability to design visually appealing and interactive reports and dashboards in Power BI Desktop using appropriate visualizations and customizations. Experience with Power BI Desktop administration tasks, such as data source management, data refresh scheduling, and performance optimization Ability to troubleshoot issues with Power BI Desktop reports and data models, including identifying and resolving errors and performance issues. Experience in using R or Python libraries for data analysis, machine learning, or statistical modeling within Power BI Desktop Basic understanding of Microsoft Azure Strong expertise in Microsoft Analysis Services (SSAS) and its components, including OLAP tabular cubes, snowflake schema, measures, DAX, and calculated columns. Proven experience in designing and implementing OLAP cubes and models using SSAS, including defining hierarchies, relationships, KPIs, and perspectives. Knowledge of data security and governance principles, including row-level security, data classification, and auditing using SSAS. Ability to troubleshoot and optimize SSAS performance issues, including partitioning, aggregation, and indexing. Understanding of data warehousing concepts, including star and snowflake schemas, data marts, and dimensional modeling, and how they apply to SSAS. Expertise in queries, sub queries, aggregate, pivot queries, inner, outer, left, right and cross joins, CRUD operations, stored procedures, functions, table design, and database relationships Experience in ETL solutions, including SSIS, data warehousing, importing, exporting, data transforming, and data distribution across multiple systems and platforms by SSIS packages. Strong understanding of data warehousing, data architecture, data snapshots, de-normalization of data to improve reads and performance on large data warehouse, creation of dimensional fact tables and dimensions. Visual Studio 2019 using SSDT SQL Server Management Studio Azure Data Studio , DAX Studio, and Tabular Editor Experience with version control tools, such as GIT or SVN, for managing database schema changes and deployments. Keywords: business intelligence rlang Delaware Illinois |
| [email protected] View All |
| 12:42 AM 19-Jan-24 |