Dan McClure

Background

About Dan McClure

Accomplished business analytics professional. Capable leader who streamlines operations through better business intelligence and reporting. Customer-focussed with a bias toward designing structured processes to be repeatable and self-sustaining. Strong SQL query skills; Ability to fully leverage data warehouses, BI tools (Microsoft Power BI, Tableau, SQL Server Reporting Services (SSRS), Crystal Reports, Access, etc.), and a variety of ERP systems (SAP, Oracle, JD Edwards, Infor/Lawson, Microsoft Dynamics AX, Sage). Extensive experience in successfully fully automating the financial reporting after the ETL process. This includes modeling the data in one master view to include everything needed from calculated or filtered value fields in SQL itself to converting all implicit measures in Power BI and writing DAX formulas. Ability to publish pbix with a complimentary semantic model, which allows for sharing a centralized data source cube and drag and drop functionality for the end user/analyst in Excel, creating a fun and hassle-free experience for all involved.