Create optimized SSAS cube from data warehouse. (SSAS 2016)

Hi I have been working with MSSQL for over 17 years. I am fully experienced as a developer and a DBA. Currently I am working at big financial organization in which I am responsible for the BI department. I have designed and the Developed the Organization’s Reporting Database which has been constructed with SQL Server 2008 R2 Enterprise Edition. The database is being updated daily from the core system with txt or excel files via SSIS or with direct connection at mainframe’s DB2 and a numerous of KPIS are being daily updated during the ETL. For isolation reasons the KPIS are replicated to another DB (with transactional replication) which exploits dashboards via Power BI and reports via SSRS to the consumers. Some KPIS are being replicated with merged (bidirectional) replication. Also, 10 Cubes in SSAS are being daily automatically processed and the end of the ETL. Several other reports are daily automatically produced and sent via email to the recipients. Finally I have designed and developed the bank’s crm DB which is published on the intranet. The DB holds full information about the customers (Customers,Addresses , Financial Data , Contacts , campaigns , etc) and covers 4 countries. To achieve this i have made partitions over the country code. The size of the Reporting DB, is about 4TB and consists of about 4.000 objects and the replicated KPI DB is 350GB. Best Regards mpalgeo

I am a lead Power BI developer at Digiroo, and am available to help with your project. I have implemented data-warehouse, business intelligence and Power BI solutions at large UK organisations (Retail, Engineering and Financial Services). I have a complete understanding of Microsoft BI Solution design, build and testing. This includes SSAS MD, SSAS TAB, Power BI Desktop, Power BI Online Service and Mobile, Power BI Embedded, Power BI API and both on-premise data and personal gateways. I have expertise in all aspects of Business Intelligence and Power BI including API/ODBC connectivity, SQL Server Data-Warehousing, SSIS ETL, complex MDX and DAX calculations and measures, and complex query definitions using M. Row level security can easily be applied to either SSAS MD or SSAS Tabular . Approach & Methodology: At Digiroo we use Agile Scrum methodology and manage development in sprints with weekly sprint planning sessions. As this is our first project with you, I will skew any milestone payments towards completion which provides some assurance of quality and delivery. At Digiroo we have years of experience, are all UK residents, trained in the UK with decades of experience working in the UK. I can provide LinkedIn profiles as required. I have the skills and experience, and have a team behind me to support where necessary. I can deliver your project quickly and effectively, and look forward to having the opportunity to discuss our methodologies and approach in more detail.

Hello, I'm ready to do changes in your ssas (cubes) , please do let me know the details of your project so that I could start work. Thanks

Hi, I'm a DWH/BI expert from Bulgaria(EU) with 7+ years of experience in the field and solid background in SQL Server BI stack. I can do that, but before committing to a deadline/price I need to more details about the DWH current state. My bid is higher than your budget, but I thinks this is a 2+ days of work, so $250 seems too low for me. Let me know if you re interested in my offer. Looking forward for your reply! Let

I have around 4+ years experience in data analytics, working on small excel reporting to big DWBI reporting work. I am an expert in developing user-friendly spreadsheets for data analysis and visualization, using pivot tables, pivot charts, and other tools. I specialize in creating interactive KPI dashboards using pivot tables, slicers, and graphs. Projects range from long-term support of data analysis and visualization needs to short-term specific projects. Skills: - Excel/VBA Automation - Excel Dashboards & Reporting (Data Visualization) - QlikView/QlikSense/Tableau (Data Warehousing and Business Intelligence) - Microsoft Access (SQL) - SAS / R Language - Data Analytics (Executive Decks/Analysis - Key Results and Insights) - Commercial Insights and Analytics Once I receive a project, my biggest priority/focus is to ensure that quality work is delivered always on time. Give me an opportunity, I will deliver you the quality. Warm Regards, Rohit Ahuja | Mobile: +91-8527610117 |

A proposal has not yet been provided

Please review my profile. I have 7.3 years experience in SQL and 4.6 years experience in SSRS, SSIS. Please let me know more details and when we will start. Sky pe: jikenjd

The offer is orientative. I would need to see the structure and volume of data to actually give you a quotation.

A proposal has not yet been provided